package com.ourteam.education.dao;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;
/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2019-09-22 15:15:08
  * Warning ! This file will be overwrite when regenerate !
  * 
 */
public class CoursePriceDAOQueryBean extends BaseQueryBean {
    
    public CoursePriceDAOQueryBean() {
		super();
    }
	
    public CoursePriceDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }
    
    public CoursePriceDAOQueryBean(BaseQueryBean aQueryBean,Map tableReplaceMap) {
        super(aQueryBean,tableReplaceMap);
    }
    
    public Criteria createCriteria() {
        
	    Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
                  oredCriteria.add(criteria);
            }
        return criteria;
     }
	
    protected Criteria createCriteriaInternal() {
	  return new Criteria(this);
    }
    
        
        
    	
		
	    
    public void addIdSelectProperty(){
		addIdSelectProperty("id");
	}
	
    public void addIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.Id,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.Id,"id");
	    }
    }
    
       
		
		
	    
    public void addCourseDefineIdSelectProperty(){
		addCourseDefineIdSelectProperty("courseDefineId");
	}
	
    public void addCourseDefineIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.CourseDefineId,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.CourseDefineId,"courseDefineId");
	    }
    }
    
       
		
		
	    
    public void addCampusIdSelectProperty(){
		addCampusIdSelectProperty("campusId");
	}
	
    public void addCampusIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.CampusId,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.CampusId,"campusId");
	    }
    }
    
       
		
		
	    
    public void addPriceSelectProperty(){
		addPriceSelectProperty("price");
	}
	
    public void addPriceSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.Price,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.Price,"price");
	    }
    }
    
       
		
		
	    
    public void addPriceUnitSelectProperty(){
		addPriceUnitSelectProperty("priceUnit");
	}
	
    public void addPriceUnitSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.PriceUnit,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.PriceUnit,"priceUnit");
	    }
    }
    
       
		
		
	    
    public void addStatusSelectProperty(){
		addStatusSelectProperty("status");
	}
	
    public void addStatusSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.Status,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.Status,"status");
	    }
    }
    
       
		
		
	    
    public void addRemarksSelectProperty(){
		addRemarksSelectProperty("remarks");
	}
	
    public void addRemarksSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.Remarks,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.Remarks,"remarks");
	    }
    }
    
       
		
		
	    
    public void addDeleteFlagSelectProperty(){
		addDeleteFlagSelectProperty("deleteFlag");
	}
	
    public void addDeleteFlagSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.DeleteFlag,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.DeleteFlag,"deleteFlag");
	    }
    }
    
       
		
		
	    
    public void addAmmountSelectProperty(){
		addAmmountSelectProperty("ammount");
	}
	
    public void addAmmountSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.Ammount,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.Ammount,"ammount");
	    }
    }
    
       
		
		
	    
    public void addChargingModeSelectProperty(){
		addChargingModeSelectProperty("chargingMode");
	}
	
    public void addChargingModeSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.ChargingMode,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.ChargingMode,"chargingMode");
	    }
    }
    
       
		
						
	    
    public void addCourseNameSelectProperty(){
		addCourseNameSelectProperty("courseName");
	}
	
    public void addCourseNameSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.CourseName,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.CourseName,"courseName");
	    }
    }
    
    	
								
	    
    public void addCampusNameSelectProperty(){
		addCampusNameSelectProperty("campusName");
	}
	
    public void addCampusNameSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICoursePriceDAO.CampusName,aAlias);
		}
		else{
			addSelectProperty(ICoursePriceDAO.CampusName,"campusName");
	    }
    }
    
    	
				
	public void addAllSelectProperties(){
		
		
	    addIdSelectProperty();
   
		
		
	    addCourseDefineIdSelectProperty();
   
		
		
	    addCampusIdSelectProperty();
   
		
		
	    addPriceSelectProperty();
   
		
		
	    addPriceUnitSelectProperty();
   
		
		
	    addStatusSelectProperty();
   
		
		
	    addRemarksSelectProperty();
   
		
		
	    addDeleteFlagSelectProperty();
   
		
		
	    addAmmountSelectProperty();
   
		
		
	    addChargingModeSelectProperty();
   
		
						
    	addCourseNameSelectProperty();
	
								
    	addCampusNameSelectProperty();
	
			    }
    
    public static class Criteria extends BaseWhereCriterion<CoursePriceDAOQueryBean> {
	
        protected Criteria(CoursePriceDAOQueryBean aParentObject) {
		    super(aParentObject);
        }
        
                  
            	
    	    	
    	        
                
        public Criteria andIdIsNull() {
            addCriterion(ICoursePriceDAO.Id + " is null");
            return this;
        }
        public Criteria andIdIsNotNull() {
            addCriterion(ICoursePriceDAO.Id + " is not null");
            return this;
        }
    
        public Criteria andIdIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.Id + " is not null AND " + ICoursePriceDAO.Id + " <> ''");
            return this;
        }
    		
    	public Criteria andIdIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.Id + " is null OR " + ICoursePriceDAO.Id + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andIdEqualTo(long value) {
        	return andIdEqualTo(Long.valueOf(value));
        }
               public Criteria andIdEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Id + " = ", value, "id");
            return this;
        }
        
        public Criteria andIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Id);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Id + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andIdNotEqualTo(long value) {
        	return andIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(ICoursePriceDAO.Id + " <>", value, "id");
            return this;
        }
               
        public Criteria andIdNotEqualToOrIsNull(long value) {
        	return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(ICoursePriceDAO.Id + " is null OR " + ICoursePriceDAO.Id + " <>", value, "id");
            return this;
        }
        
        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Id);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Id + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThan(long value) {
        	return andIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Id + " >", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Id);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Id + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThanOrEqualTo(long value) {
        	return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Id + " >=", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Id);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Id + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThan(long value) {
        	return andIdLessThan(Long.valueOf(value));
        }
                public Criteria andIdLessThan(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Id + " <", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Id);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Id + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThanOrEqualTo(long value) {
        	return andIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Id + " <=", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Id);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Id + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andIdIn(long[] values) {
        	if(values.length == 1){
        		return andIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Id + " in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
                public Criteria andIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Id + " in", values, "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Id + " in", Arrays.asList(values), "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Id + " not in", Arrays.asList(values), "id");
            	return this;
            }
        }
		
		public Criteria andIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Id + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Id + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdBetween(long value1,long value2) {
        	addCriterion(ICoursePriceDAO.Id + " between", value1, value2, "id");
            return this;
        }
                public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICoursePriceDAO.Id + " between", value1, value2, "id");
            return this;
        }
        
                
        public Criteria andIdNotBetween(long value1,long value2) {
        	addCriterion(ICoursePriceDAO.Id + " not between", value1, value2, "id");
            return this;
        }
                public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICoursePriceDAO.Id + " not between", value1, value2, "id");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andCourseDefineIdIsNull() {
            addCriterion(ICoursePriceDAO.CourseDefineId + " is null");
            return this;
        }
        public Criteria andCourseDefineIdIsNotNull() {
            addCriterion(ICoursePriceDAO.CourseDefineId + " is not null");
            return this;
        }
    
        public Criteria andCourseDefineIdIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.CourseDefineId + " is not null AND " + ICoursePriceDAO.CourseDefineId + " <> ''");
            return this;
        }
    		
    	public Criteria andCourseDefineIdIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.CourseDefineId + " is null OR " + ICoursePriceDAO.CourseDefineId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andCourseDefineIdEqualTo(long value) {
        	return andCourseDefineIdEqualTo(Long.valueOf(value));
        }
               public Criteria andCourseDefineIdEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CourseDefineId + " = ", value, "courseDefineId");
            return this;
        }
        
        public Criteria andCourseDefineIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseDefineId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseDefineIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseDefineId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andCourseDefineIdNotEqualTo(long value) {
        	return andCourseDefineIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andCourseDefineIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(ICoursePriceDAO.CourseDefineId + " <>", value, "courseDefineId");
            return this;
        }
               
        public Criteria andCourseDefineIdNotEqualToOrIsNull(long value) {
        	return andCourseDefineIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andCourseDefineIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(ICoursePriceDAO.CourseDefineId + " is null OR " + ICoursePriceDAO.CourseDefineId + " <>", value, "courseDefineId");
            return this;
        }
        
        public Criteria andCourseDefineIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseDefineId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseDefineIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseDefineId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andCourseDefineIdGreaterThan(long value) {
        	return andCourseDefineIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andCourseDefineIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CourseDefineId + " >", value, "courseDefineId");
            return this;
        }
        
        public Criteria andCourseDefineIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseDefineId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseDefineIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseDefineId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andCourseDefineIdGreaterThanOrEqualTo(long value) {
        	return andCourseDefineIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andCourseDefineIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CourseDefineId + " >=", value, "courseDefineId");
            return this;
        }
        
        public Criteria andCourseDefineIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseDefineId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseDefineIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseDefineId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andCourseDefineIdLessThan(long value) {
        	return andCourseDefineIdLessThan(Long.valueOf(value));
        }
                public Criteria andCourseDefineIdLessThan(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CourseDefineId + " <", value, "courseDefineId");
            return this;
        }
        
        public Criteria andCourseDefineIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseDefineId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseDefineIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseDefineId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andCourseDefineIdLessThanOrEqualTo(long value) {
        	return andCourseDefineIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andCourseDefineIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CourseDefineId + " <=", value, "courseDefineId");
            return this;
        }
        
        public Criteria andCourseDefineIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseDefineId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseDefineIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseDefineId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andCourseDefineIdIn(long[] values) {
        	if(values.length == 1){
        		return andCourseDefineIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseDefineId + " in", values, "courseDefineId");
            	return this;
            }
        }
        
        public Criteria andCourseDefineIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andCourseDefineIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseDefineId + " not in", values, "courseDefineId");
            	return this;
            }
        }
        
                public Criteria andCourseDefineIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andCourseDefineIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseDefineId + " in", values, "courseDefineId");
            	return this;
            }
        }
        public Criteria andCourseDefineIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andCourseDefineIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseDefineId + " not in", values, "courseDefineId");
            	return this;
            }
        }
        
        public Criteria andCourseDefineIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andCourseDefineIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseDefineId + " in", Arrays.asList(values), "courseDefineId");
            	return this;
            }
        }
        public Criteria andCourseDefineIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andCourseDefineIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseDefineId + " not in", Arrays.asList(values), "courseDefineId");
            	return this;
            }
        }
		
		public Criteria andCourseDefineIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseDefineId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCourseDefineIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseDefineId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andCourseDefineIdBetween(long value1,long value2) {
        	addCriterion(ICoursePriceDAO.CourseDefineId + " between", value1, value2, "courseDefineId");
            return this;
        }
                public Criteria andCourseDefineIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICoursePriceDAO.CourseDefineId + " between", value1, value2, "courseDefineId");
            return this;
        }
        
                
        public Criteria andCourseDefineIdNotBetween(long value1,long value2) {
        	addCriterion(ICoursePriceDAO.CourseDefineId + " not between", value1, value2, "courseDefineId");
            return this;
        }
                public Criteria andCourseDefineIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICoursePriceDAO.CourseDefineId + " not between", value1, value2, "courseDefineId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andCampusIdIsNull() {
            addCriterion(ICoursePriceDAO.CampusId + " is null");
            return this;
        }
        public Criteria andCampusIdIsNotNull() {
            addCriterion(ICoursePriceDAO.CampusId + " is not null");
            return this;
        }
    
        public Criteria andCampusIdIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.CampusId + " is not null AND " + ICoursePriceDAO.CampusId + " <> ''");
            return this;
        }
    		
    	public Criteria andCampusIdIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.CampusId + " is null OR " + ICoursePriceDAO.CampusId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andCampusIdEqualTo(long value) {
        	return andCampusIdEqualTo(Long.valueOf(value));
        }
               public Criteria andCampusIdEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CampusId + " = ", value, "campusId");
            return this;
        }
        
        public Criteria andCampusIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andCampusIdNotEqualTo(long value) {
        	return andCampusIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andCampusIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(ICoursePriceDAO.CampusId + " <>", value, "campusId");
            return this;
        }
               
        public Criteria andCampusIdNotEqualToOrIsNull(long value) {
        	return andCampusIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andCampusIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(ICoursePriceDAO.CampusId + " is null OR " + ICoursePriceDAO.CampusId + " <>", value, "campusId");
            return this;
        }
        
        public Criteria andCampusIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andCampusIdGreaterThan(long value) {
        	return andCampusIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andCampusIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CampusId + " >", value, "campusId");
            return this;
        }
        
        public Criteria andCampusIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andCampusIdGreaterThanOrEqualTo(long value) {
        	return andCampusIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andCampusIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CampusId + " >=", value, "campusId");
            return this;
        }
        
        public Criteria andCampusIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andCampusIdLessThan(long value) {
        	return andCampusIdLessThan(Long.valueOf(value));
        }
                public Criteria andCampusIdLessThan(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CampusId + " <", value, "campusId");
            return this;
        }
        
        public Criteria andCampusIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andCampusIdLessThanOrEqualTo(long value) {
        	return andCampusIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andCampusIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.CampusId + " <=", value, "campusId");
            return this;
        }
        
        public Criteria andCampusIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andCampusIdIn(long[] values) {
        	if(values.length == 1){
        		return andCampusIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusId + " in", values, "campusId");
            	return this;
            }
        }
        
        public Criteria andCampusIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andCampusIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusId + " not in", values, "campusId");
            	return this;
            }
        }
        
                public Criteria andCampusIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andCampusIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusId + " in", values, "campusId");
            	return this;
            }
        }
        public Criteria andCampusIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andCampusIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusId + " not in", values, "campusId");
            	return this;
            }
        }
        
        public Criteria andCampusIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andCampusIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusId + " in", Arrays.asList(values), "campusId");
            	return this;
            }
        }
        public Criteria andCampusIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andCampusIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusId + " not in", Arrays.asList(values), "campusId");
            	return this;
            }
        }
		
		public Criteria andCampusIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCampusIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andCampusIdBetween(long value1,long value2) {
        	addCriterion(ICoursePriceDAO.CampusId + " between", value1, value2, "campusId");
            return this;
        }
                public Criteria andCampusIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICoursePriceDAO.CampusId + " between", value1, value2, "campusId");
            return this;
        }
        
                
        public Criteria andCampusIdNotBetween(long value1,long value2) {
        	addCriterion(ICoursePriceDAO.CampusId + " not between", value1, value2, "campusId");
            return this;
        }
                public Criteria andCampusIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICoursePriceDAO.CampusId + " not between", value1, value2, "campusId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andPriceIsNull() {
            addCriterion(ICoursePriceDAO.Price + " is null");
            return this;
        }
        public Criteria andPriceIsNotNull() {
            addCriterion(ICoursePriceDAO.Price + " is not null");
            return this;
        }
    
        public Criteria andPriceIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.Price + " is not null AND " + ICoursePriceDAO.Price + " <> ''");
            return this;
        }
    		
    	public Criteria andPriceIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.Price + " is null OR " + ICoursePriceDAO.Price + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andPriceEqualTo(double value) {
        	return andPriceEqualTo(Double.valueOf(value));
        }
               public Criteria andPriceEqualTo(java.lang.Double value) {
        				
            addCriterion(ICoursePriceDAO.Price + " = ", value, "price");
            return this;
        }
        
        public Criteria andPriceEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Price);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Price + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andPriceNotEqualTo(double value) {
        	return andPriceNotEqualTo(Double.valueOf(value));
        }
                public Criteria andPriceNotEqualTo(java.lang.Double value) {
        	        
            addCriterion(ICoursePriceDAO.Price + " <>", value, "price");
            return this;
        }
               
        public Criteria andPriceNotEqualToOrIsNull(double value) {
        	return andPriceNotEqualToOrIsNull(Double.valueOf(value));
        }
                
        public Criteria andPriceNotEqualToOrIsNull(java.lang.Double value) {
        	        
            addCriterion(ICoursePriceDAO.Price + " is null OR " + ICoursePriceDAO.Price + " <>", value, "price");
            return this;
        }
        
        public Criteria andPriceNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Price);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Price + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andPriceGreaterThan(double value) {
        	return andPriceGreaterThan(Double.valueOf(value));
        }
                public Criteria andPriceGreaterThan(java.lang.Double value) {
        				
            addCriterion(ICoursePriceDAO.Price + " >", value, "price");
            return this;
        }
        
        public Criteria andPriceGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Price);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Price + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andPriceGreaterThanOrEqualTo(double value) {
        	return andPriceGreaterThanOrEqualTo(Double.valueOf(value));
        }
                public Criteria andPriceGreaterThanOrEqualTo(java.lang.Double value) {
        				
            addCriterion(ICoursePriceDAO.Price + " >=", value, "price");
            return this;
        }
        
        public Criteria andPriceGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Price);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Price + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andPriceLessThan(double value) {
        	return andPriceLessThan(Double.valueOf(value));
        }
                public Criteria andPriceLessThan(java.lang.Double value) {
        				
            addCriterion(ICoursePriceDAO.Price + " <", value, "price");
            return this;
        }
        
        public Criteria andPriceLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Price);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Price + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andPriceLessThanOrEqualTo(double value) {
        	return andPriceLessThanOrEqualTo(Double.valueOf(value));
        }
                public Criteria andPriceLessThanOrEqualTo(java.lang.Double value) {
        				
            addCriterion(ICoursePriceDAO.Price + " <=", value, "price");
            return this;
        }
        
        public Criteria andPriceLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Price);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Price + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andPriceIn(double[] values) {
        	if(values.length == 1){
        		return andPriceEqualTo((java.lang.Double)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Price + " in", values, "price");
            	return this;
            }
        }
        
        public Criteria andPriceNotIn(double[] values) {
        	if(values.length == 1){
        		return andPriceNotEqualTo((java.lang.Double)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Price + " not in", values, "price");
            	return this;
            }
        }
        
                public Criteria andPriceIn(List<java.lang.Double> values) {
        	
        	if(values.size() == 1){
        		return andPriceEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Price + " in", values, "price");
            	return this;
            }
        }
        public Criteria andPriceNotIn(List<java.lang.Double> values) {
        	if(values.size() == 1){
        		return andPriceNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Price + " not in", values, "price");
            	return this;
            }
        }
        
        public Criteria andPriceIn(java.lang.Double[] values) {
        	
        	if(values.length == 1){
        		return andPriceEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Price + " in", Arrays.asList(values), "price");
            	return this;
            }
        }
        public Criteria andPriceNotIn(java.lang.Double[] values) {
        	if(values.length == 1){
        		return andPriceNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Price + " not in", Arrays.asList(values), "price");
            	return this;
            }
        }
		
		public Criteria andPriceIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Price + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andPriceNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Price + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andPriceBetween(double value1,double value2) {
        	addCriterion(ICoursePriceDAO.Price + " between", value1, value2, "price");
            return this;
        }
                public Criteria andPriceBetween(java.lang.Double value1, java.lang.Double value2) {
            addCriterion(ICoursePriceDAO.Price + " between", value1, value2, "price");
            return this;
        }
        
                
        public Criteria andPriceNotBetween(double value1,double value2) {
        	addCriterion(ICoursePriceDAO.Price + " not between", value1, value2, "price");
            return this;
        }
                public Criteria andPriceNotBetween(java.lang.Double value1, java.lang.Double value2) {
            addCriterion(ICoursePriceDAO.Price + " not between", value1, value2, "price");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andPriceUnitIsNull() {
            addCriterion(ICoursePriceDAO.PriceUnit + " is null");
            return this;
        }
        public Criteria andPriceUnitIsNotNull() {
            addCriterion(ICoursePriceDAO.PriceUnit + " is not null");
            return this;
        }
    
        public Criteria andPriceUnitIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.PriceUnit + " is not null AND " + ICoursePriceDAO.PriceUnit + " <> ''");
            return this;
        }
    		
    	public Criteria andPriceUnitIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.PriceUnit + " is null OR " + ICoursePriceDAO.PriceUnit + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andPriceUnitEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.PriceUnit + " = ", value, "priceUnit");
            return this;
        }
        
        public Criteria andPriceUnitEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.PriceUnit);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceUnitEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.PriceUnit + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andPriceUnitNotEqualTo(String value) {
        	        
            addCriterion(ICoursePriceDAO.PriceUnit + " <>", value, "priceUnit");
            return this;
        }
               
        public Criteria andPriceUnitNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICoursePriceDAO.PriceUnit + " is null OR " + ICoursePriceDAO.PriceUnit + " <>", value, "priceUnit");
            return this;
        }
        
        public Criteria andPriceUnitNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.PriceUnit);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceUnitNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.PriceUnit + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andPriceUnitGreaterThan(String value) {
        				
            addCriterion(ICoursePriceDAO.PriceUnit + " >", value, "priceUnit");
            return this;
        }
        
        public Criteria andPriceUnitGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.PriceUnit);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceUnitGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.PriceUnit + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andPriceUnitGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.PriceUnit + " >=", value, "priceUnit");
            return this;
        }
        
        public Criteria andPriceUnitGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.PriceUnit);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceUnitGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.PriceUnit + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andPriceUnitLessThan(String value) {
        				
            addCriterion(ICoursePriceDAO.PriceUnit + " <", value, "priceUnit");
            return this;
        }
        
        public Criteria andPriceUnitLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.PriceUnit);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceUnitLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.PriceUnit + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andPriceUnitLessThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.PriceUnit + " <=", value, "priceUnit");
            return this;
        }
        
        public Criteria andPriceUnitLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.PriceUnit);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andPriceUnitLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.PriceUnit + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andPriceUnitLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.PriceUnit + " like", buffer.toString(), "priceUnit");
            return this;
        }
        public Criteria andPriceUnitNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.PriceUnit + " not like", buffer.toString(), "priceUnit");
            return this;
        }
                
                public Criteria andPriceUnitIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andPriceUnitEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.PriceUnit + " in", values, "priceUnit");
            	return this;
            }
        }
        public Criteria andPriceUnitNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andPriceUnitNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.PriceUnit + " not in", values, "priceUnit");
            	return this;
            }
        }
        
        public Criteria andPriceUnitIn(String[] values) {
        	
        	if(values.length == 1){
        		return andPriceUnitEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.PriceUnit + " in", Arrays.asList(values), "priceUnit");
            	return this;
            }
        }
        public Criteria andPriceUnitNotIn(String[] values) {
        	if(values.length == 1){
        		return andPriceUnitNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.PriceUnit + " not in", Arrays.asList(values), "priceUnit");
            	return this;
            }
        }
		
		public Criteria andPriceUnitIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.PriceUnit + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andPriceUnitNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.PriceUnit + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andPriceUnitBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.PriceUnit + " between", value1, value2, "priceUnit");
            return this;
        }
        
                public Criteria andPriceUnitNotBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.PriceUnit + " not between", value1, value2, "priceUnit");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andStatusIsNull() {
            addCriterion(ICoursePriceDAO.Status + " is null");
            return this;
        }
        public Criteria andStatusIsNotNull() {
            addCriterion(ICoursePriceDAO.Status + " is not null");
            return this;
        }
    
        public Criteria andStatusIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.Status + " is not null AND " + ICoursePriceDAO.Status + " <> ''");
            return this;
        }
    		
    	public Criteria andStatusIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.Status + " is null OR " + ICoursePriceDAO.Status + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andStatusEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.Status + " = ", value, "status");
            return this;
        }
        
        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Status);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Status + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andStatusNotEqualTo(String value) {
        	        
            addCriterion(ICoursePriceDAO.Status + " <>", value, "status");
            return this;
        }
               
        public Criteria andStatusNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICoursePriceDAO.Status + " is null OR " + ICoursePriceDAO.Status + " <>", value, "status");
            return this;
        }
        
        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Status);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Status + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThan(String value) {
        				
            addCriterion(ICoursePriceDAO.Status + " >", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Status);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Status + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.Status + " >=", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Status);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Status + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThan(String value) {
        				
            addCriterion(ICoursePriceDAO.Status + " <", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Status);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Status + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.Status + " <=", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Status);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Status + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andStatusLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.Status + " like", buffer.toString(), "status");
            return this;
        }
        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.Status + " not like", buffer.toString(), "status");
            return this;
        }
                
                public Criteria andStatusIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andStatusEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Status + " in", values, "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andStatusNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Status + " not in", values, "status");
            	return this;
            }
        }
        
        public Criteria andStatusIn(String[] values) {
        	
        	if(values.length == 1){
        		return andStatusEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Status + " in", Arrays.asList(values), "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(String[] values) {
        	if(values.length == 1){
        		return andStatusNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Status + " not in", Arrays.asList(values), "status");
            	return this;
            }
        }
		
		public Criteria andStatusIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Status + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Status + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.Status + " between", value1, value2, "status");
            return this;
        }
        
                public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.Status + " not between", value1, value2, "status");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andRemarksIsNull() {
            addCriterion(ICoursePriceDAO.Remarks + " is null");
            return this;
        }
        public Criteria andRemarksIsNotNull() {
            addCriterion(ICoursePriceDAO.Remarks + " is not null");
            return this;
        }
    
        public Criteria andRemarksIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.Remarks + " is not null AND " + ICoursePriceDAO.Remarks + " <> ''");
            return this;
        }
    		
    	public Criteria andRemarksIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.Remarks + " is null OR " + ICoursePriceDAO.Remarks + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andRemarksEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.Remarks + " = ", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Remarks);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Remarks + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andRemarksNotEqualTo(String value) {
        	        
            addCriterion(ICoursePriceDAO.Remarks + " <>", value, "remarks");
            return this;
        }
               
        public Criteria andRemarksNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICoursePriceDAO.Remarks + " is null OR " + ICoursePriceDAO.Remarks + " <>", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Remarks);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Remarks + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThan(String value) {
        				
            addCriterion(ICoursePriceDAO.Remarks + " >", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Remarks);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Remarks + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.Remarks + " >=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Remarks);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Remarks + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThan(String value) {
        				
            addCriterion(ICoursePriceDAO.Remarks + " <", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Remarks);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Remarks + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.Remarks + " <=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Remarks);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Remarks + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andRemarksLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.Remarks + " like", buffer.toString(), "remarks");
            return this;
        }
        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.Remarks + " not like", buffer.toString(), "remarks");
            return this;
        }
                
                public Criteria andRemarksIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andRemarksEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Remarks + " in", values, "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andRemarksNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Remarks + " not in", values, "remarks");
            	return this;
            }
        }
        
        public Criteria andRemarksIn(String[] values) {
        	
        	if(values.length == 1){
        		return andRemarksEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Remarks + " in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(String[] values) {
        	if(values.length == 1){
        		return andRemarksNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Remarks + " not in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
		
		public Criteria andRemarksIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Remarks + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Remarks + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.Remarks + " between", value1, value2, "remarks");
            return this;
        }
        
                public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.Remarks + " not between", value1, value2, "remarks");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andDeleteFlagIsNull() {
            addCriterion(ICoursePriceDAO.DeleteFlag + " is null");
            return this;
        }
        public Criteria andDeleteFlagIsNotNull() {
            addCriterion(ICoursePriceDAO.DeleteFlag + " is not null");
            return this;
        }
    
        public Criteria andDeleteFlagIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.DeleteFlag + " is not null AND " + ICoursePriceDAO.DeleteFlag + " <> ''");
            return this;
        }
    		
    	public Criteria andDeleteFlagIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.DeleteFlag + " is null OR " + ICoursePriceDAO.DeleteFlag + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andDeleteFlagEqualTo(int value) {
        	return andDeleteFlagEqualTo(Integer.valueOf(value));
        }
               public Criteria andDeleteFlagEqualTo(java.lang.Integer value) {
        				
            addCriterion(ICoursePriceDAO.DeleteFlag + " = ", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.DeleteFlag);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.DeleteFlag + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andDeleteFlagNotEqualTo(int value) {
        	return andDeleteFlagNotEqualTo(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagNotEqualTo(java.lang.Integer value) {
        	        
            addCriterion(ICoursePriceDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
               
        public Criteria andDeleteFlagNotEqualToOrIsNull(int value) {
        	return andDeleteFlagNotEqualToOrIsNull(Integer.valueOf(value));
        }
                
        public Criteria andDeleteFlagNotEqualToOrIsNull(java.lang.Integer value) {
        	        
            addCriterion(ICoursePriceDAO.DeleteFlag + " is null OR " + ICoursePriceDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.DeleteFlag);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.DeleteFlag + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThan(int value) {
        	return andDeleteFlagGreaterThan(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThan(java.lang.Integer value) {
        				
            addCriterion(ICoursePriceDAO.DeleteFlag + " >", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.DeleteFlag);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.DeleteFlag + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThanOrEqualTo(int value) {
        	return andDeleteFlagGreaterThanOrEqualTo(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThanOrEqualTo(java.lang.Integer value) {
        				
            addCriterion(ICoursePriceDAO.DeleteFlag + " >=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.DeleteFlag);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.DeleteFlag + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThan(int value) {
        	return andDeleteFlagLessThan(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagLessThan(java.lang.Integer value) {
        				
            addCriterion(ICoursePriceDAO.DeleteFlag + " <", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.DeleteFlag);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.DeleteFlag + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThanOrEqualTo(int value) {
        	return andDeleteFlagLessThanOrEqualTo(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagLessThanOrEqualTo(java.lang.Integer value) {
        				
            addCriterion(ICoursePriceDAO.DeleteFlag + " <=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.DeleteFlag);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.DeleteFlag + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andDeleteFlagIn(int[] values) {
        	if(values.length == 1){
        		return andDeleteFlagEqualTo((java.lang.Integer)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagNotIn(int[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo((java.lang.Integer)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
                public Criteria andDeleteFlagIn(List<java.lang.Integer> values) {
        	
        	if(values.size() == 1){
        		return andDeleteFlagEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(List<java.lang.Integer> values) {
        	if(values.size() == 1){
        		return andDeleteFlagNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagIn(java.lang.Integer[] values) {
        	
        	if(values.length == 1){
        		return andDeleteFlagEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.DeleteFlag + " in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(java.lang.Integer[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.DeleteFlag + " not in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
		
		public Criteria andDeleteFlagIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.DeleteFlag + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andDeleteFlagNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.DeleteFlag + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagBetween(int value1,int value2) {
        	addCriterion(ICoursePriceDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagBetween(java.lang.Integer value1, java.lang.Integer value2) {
            addCriterion(ICoursePriceDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
        
                
        public Criteria andDeleteFlagNotBetween(int value1,int value2) {
        	addCriterion(ICoursePriceDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagNotBetween(java.lang.Integer value1, java.lang.Integer value2) {
            addCriterion(ICoursePriceDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andAmmountIsNull() {
            addCriterion(ICoursePriceDAO.Ammount + " is null");
            return this;
        }
        public Criteria andAmmountIsNotNull() {
            addCriterion(ICoursePriceDAO.Ammount + " is not null");
            return this;
        }
    
        public Criteria andAmmountIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.Ammount + " is not null AND " + ICoursePriceDAO.Ammount + " <> ''");
            return this;
        }
    		
    	public Criteria andAmmountIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.Ammount + " is null OR " + ICoursePriceDAO.Ammount + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andAmmountEqualTo(long value) {
        	return andAmmountEqualTo(Long.valueOf(value));
        }
               public Criteria andAmmountEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Ammount + " = ", value, "ammount");
            return this;
        }
        
        public Criteria andAmmountEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Ammount);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andAmmountEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Ammount + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andAmmountNotEqualTo(long value) {
        	return andAmmountNotEqualTo(Long.valueOf(value));
        }
                public Criteria andAmmountNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(ICoursePriceDAO.Ammount + " <>", value, "ammount");
            return this;
        }
               
        public Criteria andAmmountNotEqualToOrIsNull(long value) {
        	return andAmmountNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andAmmountNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(ICoursePriceDAO.Ammount + " is null OR " + ICoursePriceDAO.Ammount + " <>", value, "ammount");
            return this;
        }
        
        public Criteria andAmmountNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Ammount);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andAmmountNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Ammount + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andAmmountGreaterThan(long value) {
        	return andAmmountGreaterThan(Long.valueOf(value));
        }
                public Criteria andAmmountGreaterThan(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Ammount + " >", value, "ammount");
            return this;
        }
        
        public Criteria andAmmountGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.Ammount);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andAmmountGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Ammount + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andAmmountGreaterThanOrEqualTo(long value) {
        	return andAmmountGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andAmmountGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Ammount + " >=", value, "ammount");
            return this;
        }
        
        public Criteria andAmmountGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Ammount);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andAmmountGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Ammount + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andAmmountLessThan(long value) {
        	return andAmmountLessThan(Long.valueOf(value));
        }
                public Criteria andAmmountLessThan(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Ammount + " <", value, "ammount");
            return this;
        }
        
        public Criteria andAmmountLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Ammount);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andAmmountLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Ammount + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andAmmountLessThanOrEqualTo(long value) {
        	return andAmmountLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andAmmountLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICoursePriceDAO.Ammount + " <=", value, "ammount");
            return this;
        }
        
        public Criteria andAmmountLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.Ammount);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andAmmountLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Ammount + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andAmmountIn(long[] values) {
        	if(values.length == 1){
        		return andAmmountEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Ammount + " in", values, "ammount");
            	return this;
            }
        }
        
        public Criteria andAmmountNotIn(long[] values) {
        	if(values.length == 1){
        		return andAmmountNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Ammount + " not in", values, "ammount");
            	return this;
            }
        }
        
                public Criteria andAmmountIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andAmmountEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Ammount + " in", values, "ammount");
            	return this;
            }
        }
        public Criteria andAmmountNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andAmmountNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Ammount + " not in", values, "ammount");
            	return this;
            }
        }
        
        public Criteria andAmmountIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andAmmountEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Ammount + " in", Arrays.asList(values), "ammount");
            	return this;
            }
        }
        public Criteria andAmmountNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andAmmountNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.Ammount + " not in", Arrays.asList(values), "ammount");
            	return this;
            }
        }
		
		public Criteria andAmmountIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Ammount + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andAmmountNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.Ammount + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andAmmountBetween(long value1,long value2) {
        	addCriterion(ICoursePriceDAO.Ammount + " between", value1, value2, "ammount");
            return this;
        }
                public Criteria andAmmountBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICoursePriceDAO.Ammount + " between", value1, value2, "ammount");
            return this;
        }
        
                
        public Criteria andAmmountNotBetween(long value1,long value2) {
        	addCriterion(ICoursePriceDAO.Ammount + " not between", value1, value2, "ammount");
            return this;
        }
                public Criteria andAmmountNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICoursePriceDAO.Ammount + " not between", value1, value2, "ammount");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andChargingModeIsNull() {
            addCriterion(ICoursePriceDAO.ChargingMode + " is null");
            return this;
        }
        public Criteria andChargingModeIsNotNull() {
            addCriterion(ICoursePriceDAO.ChargingMode + " is not null");
            return this;
        }
    
        public Criteria andChargingModeIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.ChargingMode + " is not null AND " + ICoursePriceDAO.ChargingMode + " <> ''");
            return this;
        }
    		
    	public Criteria andChargingModeIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.ChargingMode + " is null OR " + ICoursePriceDAO.ChargingMode + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andChargingModeEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.ChargingMode + " = ", value, "chargingMode");
            return this;
        }
        
        public Criteria andChargingModeEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.ChargingMode);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andChargingModeEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.ChargingMode + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andChargingModeNotEqualTo(String value) {
        	        
            addCriterion(ICoursePriceDAO.ChargingMode + " <>", value, "chargingMode");
            return this;
        }
               
        public Criteria andChargingModeNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICoursePriceDAO.ChargingMode + " is null OR " + ICoursePriceDAO.ChargingMode + " <>", value, "chargingMode");
            return this;
        }
        
        public Criteria andChargingModeNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.ChargingMode);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andChargingModeNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.ChargingMode + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andChargingModeGreaterThan(String value) {
        				
            addCriterion(ICoursePriceDAO.ChargingMode + " >", value, "chargingMode");
            return this;
        }
        
        public Criteria andChargingModeGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.ChargingMode);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andChargingModeGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.ChargingMode + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andChargingModeGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.ChargingMode + " >=", value, "chargingMode");
            return this;
        }
        
        public Criteria andChargingModeGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.ChargingMode);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andChargingModeGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.ChargingMode + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andChargingModeLessThan(String value) {
        				
            addCriterion(ICoursePriceDAO.ChargingMode + " <", value, "chargingMode");
            return this;
        }
        
        public Criteria andChargingModeLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.ChargingMode);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andChargingModeLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.ChargingMode + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andChargingModeLessThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.ChargingMode + " <=", value, "chargingMode");
            return this;
        }
        
        public Criteria andChargingModeLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.ChargingMode);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andChargingModeLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.ChargingMode + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andChargingModeLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.ChargingMode + " like", buffer.toString(), "chargingMode");
            return this;
        }
        public Criteria andChargingModeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.ChargingMode + " not like", buffer.toString(), "chargingMode");
            return this;
        }
                
                public Criteria andChargingModeIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andChargingModeEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.ChargingMode + " in", values, "chargingMode");
            	return this;
            }
        }
        public Criteria andChargingModeNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andChargingModeNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.ChargingMode + " not in", values, "chargingMode");
            	return this;
            }
        }
        
        public Criteria andChargingModeIn(String[] values) {
        	
        	if(values.length == 1){
        		return andChargingModeEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.ChargingMode + " in", Arrays.asList(values), "chargingMode");
            	return this;
            }
        }
        public Criteria andChargingModeNotIn(String[] values) {
        	if(values.length == 1){
        		return andChargingModeNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.ChargingMode + " not in", Arrays.asList(values), "chargingMode");
            	return this;
            }
        }
		
		public Criteria andChargingModeIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.ChargingMode + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andChargingModeNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.ChargingMode + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andChargingModeBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.ChargingMode + " between", value1, value2, "chargingMode");
            return this;
        }
        
                public Criteria andChargingModeNotBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.ChargingMode + " not between", value1, value2, "chargingMode");
            return this;
        }
        
            	
    	    	
    	    	    	    	    	    	
                
                
        public Criteria andCourseNameIsNull() {
            addCriterion(ICoursePriceDAO.CourseName + " is null");
            return this;
        }
        public Criteria andCourseNameIsNotNull() {
            addCriterion(ICoursePriceDAO.CourseName + " is not null");
            return this;
        }
    
        public Criteria andCourseNameIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.CourseName + " is not null AND " + ICoursePriceDAO.CourseName + " <> ''");
            return this;
        }
    		
    	public Criteria andCourseNameIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.CourseName + " is null OR " + ICoursePriceDAO.CourseName + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andCourseNameEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.CourseName + " = ", value, "courseName");
            return this;
        }
        
        public Criteria andCourseNameEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseName);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseNameEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseName + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andCourseNameNotEqualTo(String value) {
        	        
            addCriterion(ICoursePriceDAO.CourseName + " <>", value, "courseName");
            return this;
        }
               
        public Criteria andCourseNameNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICoursePriceDAO.CourseName + " is null OR " + ICoursePriceDAO.CourseName + " <>", value, "courseName");
            return this;
        }
        
        public Criteria andCourseNameNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseName);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseNameNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseName + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andCourseNameGreaterThan(String value) {
        				
            addCriterion(ICoursePriceDAO.CourseName + " >", value, "courseName");
            return this;
        }
        
        public Criteria andCourseNameGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseName);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseNameGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseName + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andCourseNameGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.CourseName + " >=", value, "courseName");
            return this;
        }
        
        public Criteria andCourseNameGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseName);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseNameGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseName + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCourseNameLessThan(String value) {
        				
            addCriterion(ICoursePriceDAO.CourseName + " <", value, "courseName");
            return this;
        }
        
        public Criteria andCourseNameLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseName);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseNameLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseName + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCourseNameLessThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.CourseName + " <=", value, "courseName");
            return this;
        }
        
        public Criteria andCourseNameLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CourseName);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCourseNameLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseName + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andCourseNameLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.CourseName + " like", buffer.toString(), "courseName");
            return this;
        }
        public Criteria andCourseNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.CourseName + " not like", buffer.toString(), "courseName");
            return this;
        }
                
                public Criteria andCourseNameIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andCourseNameEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseName + " in", values, "courseName");
            	return this;
            }
        }
        public Criteria andCourseNameNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andCourseNameNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseName + " not in", values, "courseName");
            	return this;
            }
        }
        
        public Criteria andCourseNameIn(String[] values) {
        	
        	if(values.length == 1){
        		return andCourseNameEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseName + " in", Arrays.asList(values), "courseName");
            	return this;
            }
        }
        public Criteria andCourseNameNotIn(String[] values) {
        	if(values.length == 1){
        		return andCourseNameNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CourseName + " not in", Arrays.asList(values), "courseName");
            	return this;
            }
        }
		
		public Criteria andCourseNameIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseName + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCourseNameNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CourseName + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCourseNameBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.CourseName + " between", value1, value2, "courseName");
            return this;
        }
        
                public Criteria andCourseNameNotBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.CourseName + " not between", value1, value2, "courseName");
            return this;
        }
        
            	
    	    	    	    	    	    	    	    	
                
                
        public Criteria andCampusNameIsNull() {
            addCriterion(ICoursePriceDAO.CampusName + " is null");
            return this;
        }
        public Criteria andCampusNameIsNotNull() {
            addCriterion(ICoursePriceDAO.CampusName + " is not null");
            return this;
        }
    
        public Criteria andCampusNameIsNotEmpty() {        
            addCriterion(ICoursePriceDAO.CampusName + " is not null AND " + ICoursePriceDAO.CampusName + " <> ''");
            return this;
        }
    		
    	public Criteria andCampusNameIsEmpty() {       
            addCriterion("(" + ICoursePriceDAO.CampusName + " is null OR " + ICoursePriceDAO.CampusName + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andCampusNameEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.CampusName + " = ", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusName);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusName + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andCampusNameNotEqualTo(String value) {
        	        
            addCriterion(ICoursePriceDAO.CampusName + " <>", value, "campusName");
            return this;
        }
               
        public Criteria andCampusNameNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICoursePriceDAO.CampusName + " is null OR " + ICoursePriceDAO.CampusName + " <>", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusName);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusName + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusNameGreaterThan(String value) {
        				
            addCriterion(ICoursePriceDAO.CampusName + " >", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusName);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusName + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusNameGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.CampusName + " >=", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusName);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusName + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusNameLessThan(String value) {
        				
            addCriterion(ICoursePriceDAO.CampusName + " <", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusName);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusName + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusNameLessThanOrEqualTo(String value) {
        				
            addCriterion(ICoursePriceDAO.CampusName + " <=", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICoursePriceDAO.CampusName);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusName + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andCampusNameLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.CampusName + " like", buffer.toString(), "campusName");
            return this;
        }
        public Criteria andCampusNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICoursePriceDAO.CampusName + " not like", buffer.toString(), "campusName");
            return this;
        }
                
                public Criteria andCampusNameIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andCampusNameEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusName + " in", values, "campusName");
            	return this;
            }
        }
        public Criteria andCampusNameNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andCampusNameNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusName + " not in", values, "campusName");
            	return this;
            }
        }
        
        public Criteria andCampusNameIn(String[] values) {
        	
        	if(values.length == 1){
        		return andCampusNameEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusName + " in", Arrays.asList(values), "campusName");
            	return this;
            }
        }
        public Criteria andCampusNameNotIn(String[] values) {
        	if(values.length == 1){
        		return andCampusNameNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICoursePriceDAO.CampusName + " not in", Arrays.asList(values), "campusName");
            	return this;
            }
        }
		
		public Criteria andCampusNameIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusName + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCampusNameNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICoursePriceDAO.CampusName + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusNameBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.CampusName + " between", value1, value2, "campusName");
            return this;
        }
        
                public Criteria andCampusNameNotBetween(String value1, String value2) {
            addCriterion(ICoursePriceDAO.CampusName + " not between", value1, value2, "campusName");
            return this;
        }
        
            	
    	    	    	        
        
    }
	
    
}